If you want to do it this way then this is the syntax you're after; IF EXISTS (SELECT * FROM tblGLUserAccess WHERE GLUserName ='xxxxxxxx') ... ... <看更多>

I have not knowledge working with Vertica but you can try using If exists like in SQL Server. If exist (Select 1 FROM sys.objects Where type = 'U' and name ... ... <看更多>

... <看更多>